﻿

create proc CheckDirectory
	@chkdirectory as nvarchar(4000),
	@Create bit = 0
	
as
begin
    declare @folder_exists as int
     
    declare @file_results table
    (file_exists int,
    file_is_a_directory int,
    parent_directory_exists int
    )
 
    insert into @file_results
    (file_exists, file_is_a_directory, parent_directory_exists)
    exec master.dbo.xp_fileexist @chkdirectory
     
    select @folder_exists = file_is_a_directory
    from @file_results
     
	if @Create != 0
	begin
		--script to create directory       
		if @folder_exists = 0
		 begin
			print 'Directory is not exists, creating new one'
			EXECUTE master.dbo.xp_create_subdir @chkdirectory
			print @chkdirectory +  'created on' + @@servername
			return 1;
		end       
		else
		begin
			return 2;
		end
	end

	return @folder_exists;
end